﻿SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Sitemaps](
	[SitemapID] [NVARCHAR](50) NOT NULL,
	[Title] [NVARCHAR](50) NOT NULL,
	[Controller] [NVARCHAR](50) NULL,
	[Action] [NVARCHAR](50) NULL,
	[Icon] [NVARCHAR](MAX) NULL,
	[ParentID] [NVARCHAR](50) NULL,
	[Order] [INT] NOT NULL,
	[Type] [NVARCHAR](50) NULL,
 CONSTRAINT [PK_Sitemap] PRIMARY KEY CLUSTERED 
(
	[SitemapID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

DELETE FROM [dbo].[Sitemaps]
GO
INSERT [dbo].[Sitemaps] ([SitemapID], [Title], [Controller], [Action], [Icon], [ParentID], [Order], [Type]) VALUES (N'CateM', N'Loại chai', NULL, NULL, NULL, N'PM', 1, N'123')
GO
INSERT [dbo].[Sitemaps] ([SitemapID], [Title], [Controller], [Action], [Icon], [ParentID], [Order], [Type]) VALUES (N'IM', N'Chai', NULL, NULL, NULL, N'PM', 2, N'123')
GO
INSERT [dbo].[Sitemaps] ([SitemapID], [Title], [Controller], [Action], [Icon], [ParentID], [Order], [Type]) VALUES (N'LM', N'Lô', NULL, NULL, NULL, N'PM', 0, N'123')
GO
INSERT [dbo].[Sitemaps] ([SitemapID], [Title], [Controller], [Action], [Icon], [ParentID], [Order], [Type]) VALUES (N'PM', N'Quản lý sản xuất', NULL, NULL, N'fa-gears', NULL, 0, N'123')
GO
INSERT [dbo].[Sitemaps] ([SitemapID], [Title], [Controller], [Action], [Icon], [ParentID], [Order], [Type]) VALUES (N'RM', N'Vai trò', N'Role', N'Index', NULL, N'SysM', 0, N'123')
GO
INSERT [dbo].[Sitemaps] ([SitemapID], [Title], [Controller], [Action], [Icon], [ParentID], [Order], [Type]) VALUES (N'SM', N'Quản lý kinh doanh', NULL, NULL, N'fa-book', NULL, 1, N'123')
GO
INSERT [dbo].[Sitemaps] ([SitemapID], [Title], [Controller], [Action], [Icon], [ParentID], [Order], [Type]) VALUES (N'SysM', N'Hệ thống', NULL, NULL, N'fa-cog', NULL, 3, N'123')
GO
INSERT [dbo].[Sitemaps] ([SitemapID], [Title], [Controller], [Action], [Icon], [ParentID], [Order], [Type]) VALUES (N'UM', N'Người sử dụng', N'User', N'Index', NULL, N'SysM', 1, N'123')
GO
INSERT [dbo].[Sitemaps] ([SitemapID], [Title], [Controller], [Action], [Icon], [ParentID], [Order], [Type]) VALUES (N'WM', N'Quản lý kho', NULL, NULL, N'fa-th-large', NULL, 2, N'123')
GO
